Example: Join Timestamps
A new dataset will be created by joining all the timestamps into a new timestamp field, listing all the timestamps in chronological order. All original data values are included in the new dataset, and will still correspond to the original timestamp to which they were mapped. Additional timestamps will be filled by either repeating the last known value, or interpolating the value.
Initial dataset:
Configuration:
Selected Fields: Field1 and Field2
Selected Timestamp: Field7 and Field8
Interpolate Values: Yes
Created Output:
-
-
Field1_Field7
-
Field1_Field8
-
Field2_Field7
-
Field2_Field8
-
Resulting dataset:
Note that the values at the start of each field will still be null, even though interpolate values was selected. The reason for this is because the are no "first" values to use for interpolation.
Related topics: